package com.xb.cloud.order.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HistorySoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public HistorySoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andHistoryIdIsNull() {
            addCriterion("history_id is null");
            return (Criteria) this;
        }

        public Criteria andHistoryIdIsNotNull() {
            addCriterion("history_id is not null");
            return (Criteria) this;
        }

        public Criteria andHistoryIdEqualTo(Long value) {
            addCriterion("history_id =", value, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdNotEqualTo(Long value) {
            addCriterion("history_id <>", value, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdGreaterThan(Long value) {
            addCriterion("history_id >", value, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdGreaterThanOrEqualTo(Long value) {
            addCriterion("history_id >=", value, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdLessThan(Long value) {
            addCriterion("history_id <", value, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdLessThanOrEqualTo(Long value) {
            addCriterion("history_id <=", value, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdIn(List<Long> values) {
            addCriterion("history_id in", values, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdNotIn(List<Long> values) {
            addCriterion("history_id not in", values, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdBetween(Long value1, Long value2) {
            addCriterion("history_id between", value1, value2, "historyId");
            return (Criteria) this;
        }

        public Criteria andHistoryIdNotBetween(Long value1, Long value2) {
            addCriterion("history_id not between", value1, value2, "historyId");
            return (Criteria) this;
        }

        public Criteria andOperateTimeIsNull() {
            addCriterion("operate_time is null");
            return (Criteria) this;
        }

        public Criteria andOperateTimeIsNotNull() {
            addCriterion("operate_time is not null");
            return (Criteria) this;
        }

        public Criteria andOperateTimeEqualTo(Date value) {
            addCriterion("operate_time =", value, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeNotEqualTo(Date value) {
            addCriterion("operate_time <>", value, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeGreaterThan(Date value) {
            addCriterion("operate_time >", value, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("operate_time >=", value, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeLessThan(Date value) {
            addCriterion("operate_time <", value, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeLessThanOrEqualTo(Date value) {
            addCriterion("operate_time <=", value, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeIn(List<Date> values) {
            addCriterion("operate_time in", values, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeNotIn(List<Date> values) {
            addCriterion("operate_time not in", values, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeBetween(Date value1, Date value2) {
            addCriterion("operate_time between", value1, value2, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateTimeNotBetween(Date value1, Date value2) {
            addCriterion("operate_time not between", value1, value2, "operateTime");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdIsNull() {
            addCriterion("operate_user_id is null");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdIsNotNull() {
            addCriterion("operate_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdEqualTo(Long value) {
            addCriterion("operate_user_id =", value, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdNotEqualTo(Long value) {
            addCriterion("operate_user_id <>", value, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdGreaterThan(Long value) {
            addCriterion("operate_user_id >", value, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("operate_user_id >=", value, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdLessThan(Long value) {
            addCriterion("operate_user_id <", value, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdLessThanOrEqualTo(Long value) {
            addCriterion("operate_user_id <=", value, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdIn(List<Long> values) {
            addCriterion("operate_user_id in", values, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdNotIn(List<Long> values) {
            addCriterion("operate_user_id not in", values, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdBetween(Long value1, Long value2) {
            addCriterion("operate_user_id between", value1, value2, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserIdNotBetween(Long value1, Long value2) {
            addCriterion("operate_user_id not between", value1, value2, "operateUserId");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameIsNull() {
            addCriterion("operate_user_name is null");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameIsNotNull() {
            addCriterion("operate_user_name is not null");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameEqualTo(String value) {
            addCriterion("operate_user_name =", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameNotEqualTo(String value) {
            addCriterion("operate_user_name <>", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameGreaterThan(String value) {
            addCriterion("operate_user_name >", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("operate_user_name >=", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameLessThan(String value) {
            addCriterion("operate_user_name <", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameLessThanOrEqualTo(String value) {
            addCriterion("operate_user_name <=", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameLike(String value) {
            addCriterion("operate_user_name like", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameNotLike(String value) {
            addCriterion("operate_user_name not like", value, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameIn(List<String> values) {
            addCriterion("operate_user_name in", values, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameNotIn(List<String> values) {
            addCriterion("operate_user_name not in", values, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameBetween(String value1, String value2) {
            addCriterion("operate_user_name between", value1, value2, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateUserNameNotBetween(String value1, String value2) {
            addCriterion("operate_user_name not between", value1, value2, "operateUserName");
            return (Criteria) this;
        }

        public Criteria andOperateTypeIsNull() {
            addCriterion("operate_type is null");
            return (Criteria) this;
        }

        public Criteria andOperateTypeIsNotNull() {
            addCriterion("operate_type is not null");
            return (Criteria) this;
        }

        public Criteria andOperateTypeEqualTo(Byte value) {
            addCriterion("operate_type =", value, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeNotEqualTo(Byte value) {
            addCriterion("operate_type <>", value, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeGreaterThan(Byte value) {
            addCriterion("operate_type >", value, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("operate_type >=", value, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeLessThan(Byte value) {
            addCriterion("operate_type <", value, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeLessThanOrEqualTo(Byte value) {
            addCriterion("operate_type <=", value, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeIn(List<Byte> values) {
            addCriterion("operate_type in", values, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeNotIn(List<Byte> values) {
            addCriterion("operate_type not in", values, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeBetween(Byte value1, Byte value2) {
            addCriterion("operate_type between", value1, value2, "operateType");
            return (Criteria) this;
        }

        public Criteria andOperateTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("operate_type not between", value1, value2, "operateType");
            return (Criteria) this;
        }

        public Criteria andUserVisibleIsNull() {
            addCriterion("user_visible is null");
            return (Criteria) this;
        }

        public Criteria andUserVisibleIsNotNull() {
            addCriterion("user_visible is not null");
            return (Criteria) this;
        }

        public Criteria andUserVisibleEqualTo(Long value) {
            addCriterion("user_visible =", value, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleNotEqualTo(Long value) {
            addCriterion("user_visible <>", value, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleGreaterThan(Long value) {
            addCriterion("user_visible >", value, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleGreaterThanOrEqualTo(Long value) {
            addCriterion("user_visible >=", value, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleLessThan(Long value) {
            addCriterion("user_visible <", value, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleLessThanOrEqualTo(Long value) {
            addCriterion("user_visible <=", value, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleIn(List<Long> values) {
            addCriterion("user_visible in", values, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleNotIn(List<Long> values) {
            addCriterion("user_visible not in", values, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleBetween(Long value1, Long value2) {
            addCriterion("user_visible between", value1, value2, "userVisible");
            return (Criteria) this;
        }

        public Criteria andUserVisibleNotBetween(Long value1, Long value2) {
            addCriterion("user_visible not between", value1, value2, "userVisible");
            return (Criteria) this;
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNull() {
            addCriterion("company_id is null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIsNotNull() {
            addCriterion("company_id is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyIdEqualTo(Long value) {
            addCriterion("company_id =", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotEqualTo(Long value) {
            addCriterion("company_id <>", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThan(Long value) {
            addCriterion("company_id >", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdGreaterThanOrEqualTo(Long value) {
            addCriterion("company_id >=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThan(Long value) {
            addCriterion("company_id <", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdLessThanOrEqualTo(Long value) {
            addCriterion("company_id <=", value, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdIn(List<Long> values) {
            addCriterion("company_id in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotIn(List<Long> values) {
            addCriterion("company_id not in", values, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdBetween(Long value1, Long value2) {
            addCriterion("company_id between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andCompanyIdNotBetween(Long value1, Long value2) {
            addCriterion("company_id not between", value1, value2, "companyId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdIsNull() {
            addCriterion("end_user_id is null");
            return (Criteria) this;
        }

        public Criteria andEndUserIdIsNotNull() {
            addCriterion("end_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andEndUserIdEqualTo(Long value) {
            addCriterion("end_user_id =", value, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdNotEqualTo(Long value) {
            addCriterion("end_user_id <>", value, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdGreaterThan(Long value) {
            addCriterion("end_user_id >", value, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("end_user_id >=", value, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdLessThan(Long value) {
            addCriterion("end_user_id <", value, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdLessThanOrEqualTo(Long value) {
            addCriterion("end_user_id <=", value, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdIn(List<Long> values) {
            addCriterion("end_user_id in", values, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdNotIn(List<Long> values) {
            addCriterion("end_user_id not in", values, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdBetween(Long value1, Long value2) {
            addCriterion("end_user_id between", value1, value2, "endUserId");
            return (Criteria) this;
        }

        public Criteria andEndUserIdNotBetween(Long value1, Long value2) {
            addCriterion("end_user_id not between", value1, value2, "endUserId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNull() {
            addCriterion("merchant_id is null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIsNotNull() {
            addCriterion("merchant_id is not null");
            return (Criteria) this;
        }

        public Criteria andMerchantIdEqualTo(Long value) {
            addCriterion("merchant_id =", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotEqualTo(Long value) {
            addCriterion("merchant_id <>", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThan(Long value) {
            addCriterion("merchant_id >", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdGreaterThanOrEqualTo(Long value) {
            addCriterion("merchant_id >=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThan(Long value) {
            addCriterion("merchant_id <", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdLessThanOrEqualTo(Long value) {
            addCriterion("merchant_id <=", value, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdIn(List<Long> values) {
            addCriterion("merchant_id in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotIn(List<Long> values) {
            addCriterion("merchant_id not in", values, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdBetween(Long value1, Long value2) {
            addCriterion("merchant_id between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andMerchantIdNotBetween(Long value1, Long value2) {
            addCriterion("merchant_id not between", value1, value2, "merchantId");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNull() {
            addCriterion("shop_id is null");
            return (Criteria) this;
        }

        public Criteria andShopIdIsNotNull() {
            addCriterion("shop_id is not null");
            return (Criteria) this;
        }

        public Criteria andShopIdEqualTo(Long value) {
            addCriterion("shop_id =", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotEqualTo(Long value) {
            addCriterion("shop_id <>", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThan(Long value) {
            addCriterion("shop_id >", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdGreaterThanOrEqualTo(Long value) {
            addCriterion("shop_id >=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThan(Long value) {
            addCriterion("shop_id <", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdLessThanOrEqualTo(Long value) {
            addCriterion("shop_id <=", value, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdIn(List<Long> values) {
            addCriterion("shop_id in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotIn(List<Long> values) {
            addCriterion("shop_id not in", values, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdBetween(Long value1, Long value2) {
            addCriterion("shop_id between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andShopIdNotBetween(Long value1, Long value2) {
            addCriterion("shop_id not between", value1, value2, "shopId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdIsNull() {
            addCriterion("parent_so_id is null");
            return (Criteria) this;
        }

        public Criteria andParentSoIdIsNotNull() {
            addCriterion("parent_so_id is not null");
            return (Criteria) this;
        }

        public Criteria andParentSoIdEqualTo(Long value) {
            addCriterion("parent_so_id =", value, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdNotEqualTo(Long value) {
            addCriterion("parent_so_id <>", value, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdGreaterThan(Long value) {
            addCriterion("parent_so_id >", value, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdGreaterThanOrEqualTo(Long value) {
            addCriterion("parent_so_id >=", value, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdLessThan(Long value) {
            addCriterion("parent_so_id <", value, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdLessThanOrEqualTo(Long value) {
            addCriterion("parent_so_id <=", value, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdIn(List<Long> values) {
            addCriterion("parent_so_id in", values, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdNotIn(List<Long> values) {
            addCriterion("parent_so_id not in", values, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdBetween(Long value1, Long value2) {
            addCriterion("parent_so_id between", value1, value2, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andParentSoIdNotBetween(Long value1, Long value2) {
            addCriterion("parent_so_id not between", value1, value2, "parentSoId");
            return (Criteria) this;
        }

        public Criteria andIsLeafIsNull() {
            addCriterion("is_leaf is null");
            return (Criteria) this;
        }

        public Criteria andIsLeafIsNotNull() {
            addCriterion("is_leaf is not null");
            return (Criteria) this;
        }

        public Criteria andIsLeafEqualTo(Byte value) {
            addCriterion("is_leaf =", value, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafNotEqualTo(Byte value) {
            addCriterion("is_leaf <>", value, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafGreaterThan(Byte value) {
            addCriterion("is_leaf >", value, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafGreaterThanOrEqualTo(Byte value) {
            addCriterion("is_leaf >=", value, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafLessThan(Byte value) {
            addCriterion("is_leaf <", value, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafLessThanOrEqualTo(Byte value) {
            addCriterion("is_leaf <=", value, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafIn(List<Byte> values) {
            addCriterion("is_leaf in", values, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafNotIn(List<Byte> values) {
            addCriterion("is_leaf not in", values, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafBetween(Byte value1, Byte value2) {
            addCriterion("is_leaf between", value1, value2, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andIsLeafNotBetween(Byte value1, Byte value2) {
            addCriterion("is_leaf not between", value1, value2, "isLeaf");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNull() {
            addCriterion("order_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNotNull() {
            addCriterion("order_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountEqualTo(BigDecimal value) {
            addCriterion("order_amount =", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_amount <>", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThan(BigDecimal value) {
            addCriterion("order_amount >", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_amount >=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThan(BigDecimal value) {
            addCriterion("order_amount <", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_amount <=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIn(List<BigDecimal> values) {
            addCriterion("order_amount in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_amount not in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_amount between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_amount not between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountIsNull() {
            addCriterion("sku_amount is null");
            return (Criteria) this;
        }

        public Criteria andSkuAmountIsNotNull() {
            addCriterion("sku_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSkuAmountEqualTo(BigDecimal value) {
            addCriterion("sku_amount =", value, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountNotEqualTo(BigDecimal value) {
            addCriterion("sku_amount <>", value, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountGreaterThan(BigDecimal value) {
            addCriterion("sku_amount >", value, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sku_amount >=", value, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountLessThan(BigDecimal value) {
            addCriterion("sku_amount <", value, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sku_amount <=", value, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountIn(List<BigDecimal> values) {
            addCriterion("sku_amount in", values, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountNotIn(List<BigDecimal> values) {
            addCriterion("sku_amount not in", values, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sku_amount between", value1, value2, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andSkuAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sku_amount not between", value1, value2, "skuAmount");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeIsNull() {
            addCriterion("delivery_fee is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeIsNotNull() {
            addCriterion("delivery_fee is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeEqualTo(BigDecimal value) {
            addCriterion("delivery_fee =", value, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeNotEqualTo(BigDecimal value) {
            addCriterion("delivery_fee <>", value, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeGreaterThan(BigDecimal value) {
            addCriterion("delivery_fee >", value, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("delivery_fee >=", value, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeLessThan(BigDecimal value) {
            addCriterion("delivery_fee <", value, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("delivery_fee <=", value, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeIn(List<BigDecimal> values) {
            addCriterion("delivery_fee in", values, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeNotIn(List<BigDecimal> values) {
            addCriterion("delivery_fee not in", values, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("delivery_fee between", value1, value2, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("delivery_fee not between", value1, value2, "deliveryFee");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountIsNull() {
            addCriterion("order_promotion_discount is null");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountIsNotNull() {
            addCriterion("order_promotion_discount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountEqualTo(BigDecimal value) {
            addCriterion("order_promotion_discount =", value, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountNotEqualTo(BigDecimal value) {
            addCriterion("order_promotion_discount <>", value, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountGreaterThan(BigDecimal value) {
            addCriterion("order_promotion_discount >", value, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_promotion_discount >=", value, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountLessThan(BigDecimal value) {
            addCriterion("order_promotion_discount <", value, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_promotion_discount <=", value, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountIn(List<BigDecimal> values) {
            addCriterion("order_promotion_discount in", values, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountNotIn(List<BigDecimal> values) {
            addCriterion("order_promotion_discount not in", values, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_promotion_discount between", value1, value2, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderPromotionDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_promotion_discount not between", value1, value2, "orderPromotionDiscount");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponIsNull() {
            addCriterion("delivery_fee_paid_by_coupon is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponIsNotNull() {
            addCriterion("delivery_fee_paid_by_coupon is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponEqualTo(BigDecimal value) {
            addCriterion("delivery_fee_paid_by_coupon =", value, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponNotEqualTo(BigDecimal value) {
            addCriterion("delivery_fee_paid_by_coupon <>", value, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponGreaterThan(BigDecimal value) {
            addCriterion("delivery_fee_paid_by_coupon >", value, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("delivery_fee_paid_by_coupon >=", value, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponLessThan(BigDecimal value) {
            addCriterion("delivery_fee_paid_by_coupon <", value, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponLessThanOrEqualTo(BigDecimal value) {
            addCriterion("delivery_fee_paid_by_coupon <=", value, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponIn(List<BigDecimal> values) {
            addCriterion("delivery_fee_paid_by_coupon in", values, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponNotIn(List<BigDecimal> values) {
            addCriterion("delivery_fee_paid_by_coupon not in", values, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("delivery_fee_paid_by_coupon between", value1, value2, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andDeliveryFeePaidByCouponNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("delivery_fee_paid_by_coupon not between", value1, value2, "deliveryFeePaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponIsNull() {
            addCriterion("order_paid_by_coupon is null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponIsNotNull() {
            addCriterion("order_paid_by_coupon is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_coupon =", value, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponNotEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_coupon <>", value, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponGreaterThan(BigDecimal value) {
            addCriterion("order_paid_by_coupon >", value, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_coupon >=", value, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponLessThan(BigDecimal value) {
            addCriterion("order_paid_by_coupon <", value, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_coupon <=", value, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_coupon in", values, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponNotIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_coupon not in", values, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_coupon between", value1, value2, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByCouponNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_coupon not between", value1, value2, "orderPaidByCoupon");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateIsNull() {
            addCriterion("order_paid_by_rebate is null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateIsNotNull() {
            addCriterion("order_paid_by_rebate is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_rebate =", value, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateNotEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_rebate <>", value, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateGreaterThan(BigDecimal value) {
            addCriterion("order_paid_by_rebate >", value, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_rebate >=", value, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateLessThan(BigDecimal value) {
            addCriterion("order_paid_by_rebate <", value, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_rebate <=", value, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_rebate in", values, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateNotIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_rebate not in", values, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_rebate between", value1, value2, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByRebateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_rebate not between", value1, value2, "orderPaidByRebate");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountIsNull() {
            addCriterion("order_paid_by_account is null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountIsNotNull() {
            addCriterion("order_paid_by_account is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_account =", value, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountNotEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_account <>", value, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountGreaterThan(BigDecimal value) {
            addCriterion("order_paid_by_account >", value, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_account >=", value, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountLessThan(BigDecimal value) {
            addCriterion("order_paid_by_account <", value, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_account <=", value, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_account in", values, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountNotIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_account not in", values, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_account between", value1, value2, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByAccountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_account not between", value1, value2, "orderPaidByAccount");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointIsNull() {
            addCriterion("order_paid_by_point is null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointIsNotNull() {
            addCriterion("order_paid_by_point is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointEqualTo(Integer value) {
            addCriterion("order_paid_by_point =", value, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointNotEqualTo(Integer value) {
            addCriterion("order_paid_by_point <>", value, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointGreaterThan(Integer value) {
            addCriterion("order_paid_by_point >", value, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_paid_by_point >=", value, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointLessThan(Integer value) {
            addCriterion("order_paid_by_point <", value, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointLessThanOrEqualTo(Integer value) {
            addCriterion("order_paid_by_point <=", value, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointIn(List<Integer> values) {
            addCriterion("order_paid_by_point in", values, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointNotIn(List<Integer> values) {
            addCriterion("order_paid_by_point not in", values, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointBetween(Integer value1, Integer value2) {
            addCriterion("order_paid_by_point between", value1, value2, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByPointNotBetween(Integer value1, Integer value2) {
            addCriterion("order_paid_by_point not between", value1, value2, "orderPaidByPoint");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersIsNull() {
            addCriterion("order_paid_by_others is null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersIsNotNull() {
            addCriterion("order_paid_by_others is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_others =", value, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersNotEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_others <>", value, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersGreaterThan(BigDecimal value) {
            addCriterion("order_paid_by_others >", value, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_others >=", value, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersLessThan(BigDecimal value) {
            addCriterion("order_paid_by_others <", value, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_paid_by_others <=", value, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_others in", values, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersNotIn(List<BigDecimal> values) {
            addCriterion("order_paid_by_others not in", values, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_others between", value1, value2, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andOrderPaidByOthersNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_paid_by_others not between", value1, value2, "orderPaidByOthers");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeIsNull() {
            addCriterion("cs_adjust_fee is null");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeIsNotNull() {
            addCriterion("cs_adjust_fee is not null");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeEqualTo(BigDecimal value) {
            addCriterion("cs_adjust_fee =", value, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeNotEqualTo(BigDecimal value) {
            addCriterion("cs_adjust_fee <>", value, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeGreaterThan(BigDecimal value) {
            addCriterion("cs_adjust_fee >", value, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("cs_adjust_fee >=", value, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeLessThan(BigDecimal value) {
            addCriterion("cs_adjust_fee <", value, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("cs_adjust_fee <=", value, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeIn(List<BigDecimal> values) {
            addCriterion("cs_adjust_fee in", values, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeNotIn(List<BigDecimal> values) {
            addCriterion("cs_adjust_fee not in", values, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cs_adjust_fee between", value1, value2, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andCsAdjustFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("cs_adjust_fee not between", value1, value2, "csAdjustFee");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNull() {
            addCriterion("payment_type is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIsNotNull() {
            addCriterion("payment_type is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeEqualTo(Byte value) {
            addCriterion("payment_type =", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotEqualTo(Byte value) {
            addCriterion("payment_type <>", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThan(Byte value) {
            addCriterion("payment_type >", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("payment_type >=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThan(Byte value) {
            addCriterion("payment_type <", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeLessThanOrEqualTo(Byte value) {
            addCriterion("payment_type <=", value, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeIn(List<Byte> values) {
            addCriterion("payment_type in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotIn(List<Byte> values) {
            addCriterion("payment_type not in", values, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeBetween(Byte value1, Byte value2) {
            addCriterion("payment_type between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("payment_type not between", value1, value2, "paymentType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeIsNull() {
            addCriterion("payment_time_limit_type is null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeIsNotNull() {
            addCriterion("payment_time_limit_type is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeEqualTo(Integer value) {
            addCriterion("payment_time_limit_type =", value, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeNotEqualTo(Integer value) {
            addCriterion("payment_time_limit_type <>", value, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeGreaterThan(Integer value) {
            addCriterion("payment_time_limit_type >", value, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("payment_time_limit_type >=", value, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeLessThan(Integer value) {
            addCriterion("payment_time_limit_type <", value, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeLessThanOrEqualTo(Integer value) {
            addCriterion("payment_time_limit_type <=", value, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeIn(List<Integer> values) {
            addCriterion("payment_time_limit_type in", values, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeNotIn(List<Integer> values) {
            addCriterion("payment_time_limit_type not in", values, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeBetween(Integer value1, Integer value2) {
            addCriterion("payment_time_limit_type between", value1, value2, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andPaymentTimeLimitTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("payment_time_limit_type not between", value1, value2, "paymentTimeLimitType");
            return (Criteria) this;
        }

        public Criteria andSoStatusIsNull() {
            addCriterion("so_status is null");
            return (Criteria) this;
        }

        public Criteria andSoStatusIsNotNull() {
            addCriterion("so_status is not null");
            return (Criteria) this;
        }

        public Criteria andSoStatusEqualTo(Integer value) {
            addCriterion("so_status =", value, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusNotEqualTo(Integer value) {
            addCriterion("so_status <>", value, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusGreaterThan(Integer value) {
            addCriterion("so_status >", value, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("so_status >=", value, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusLessThan(Integer value) {
            addCriterion("so_status <", value, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusLessThanOrEqualTo(Integer value) {
            addCriterion("so_status <=", value, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusIn(List<Integer> values) {
            addCriterion("so_status in", values, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusNotIn(List<Integer> values) {
            addCriterion("so_status not in", values, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusBetween(Integer value1, Integer value2) {
            addCriterion("so_status between", value1, value2, "soStatus");
            return (Criteria) this;
        }

        public Criteria andSoStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("so_status not between", value1, value2, "soStatus");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeIsNull() {
            addCriterion("payment_confirm_time is null");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeIsNotNull() {
            addCriterion("payment_confirm_time is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeEqualTo(Date value) {
            addCriterion("payment_confirm_time =", value, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeNotEqualTo(Date value) {
            addCriterion("payment_confirm_time <>", value, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeGreaterThan(Date value) {
            addCriterion("payment_confirm_time >", value, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("payment_confirm_time >=", value, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeLessThan(Date value) {
            addCriterion("payment_confirm_time <", value, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeLessThanOrEqualTo(Date value) {
            addCriterion("payment_confirm_time <=", value, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeIn(List<Date> values) {
            addCriterion("payment_confirm_time in", values, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeNotIn(List<Date> values) {
            addCriterion("payment_confirm_time not in", values, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeBetween(Date value1, Date value2) {
            addCriterion("payment_confirm_time between", value1, value2, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPaymentConfirmTimeNotBetween(Date value1, Date value2) {
            addCriterion("payment_confirm_time not between", value1, value2, "paymentConfirmTime");
            return (Criteria) this;
        }

        public Criteria andPointAwardIsNull() {
            addCriterion("point_award is null");
            return (Criteria) this;
        }

        public Criteria andPointAwardIsNotNull() {
            addCriterion("point_award is not null");
            return (Criteria) this;
        }

        public Criteria andPointAwardEqualTo(Integer value) {
            addCriterion("point_award =", value, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardNotEqualTo(Integer value) {
            addCriterion("point_award <>", value, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardGreaterThan(Integer value) {
            addCriterion("point_award >", value, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardGreaterThanOrEqualTo(Integer value) {
            addCriterion("point_award >=", value, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardLessThan(Integer value) {
            addCriterion("point_award <", value, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardLessThanOrEqualTo(Integer value) {
            addCriterion("point_award <=", value, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardIn(List<Integer> values) {
            addCriterion("point_award in", values, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardNotIn(List<Integer> values) {
            addCriterion("point_award not in", values, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardBetween(Integer value1, Integer value2) {
            addCriterion("point_award between", value1, value2, "pointAward");
            return (Criteria) this;
        }

        public Criteria andPointAwardNotBetween(Integer value1, Integer value2) {
            addCriterion("point_award not between", value1, value2, "pointAward");
            return (Criteria) this;
        }

        public Criteria andSoPlatformIsNull() {
            addCriterion("so_platform is null");
            return (Criteria) this;
        }

        public Criteria andSoPlatformIsNotNull() {
            addCriterion("so_platform is not null");
            return (Criteria) this;
        }

        public Criteria andSoPlatformEqualTo(Integer value) {
            addCriterion("so_platform =", value, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformNotEqualTo(Integer value) {
            addCriterion("so_platform <>", value, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformGreaterThan(Integer value) {
            addCriterion("so_platform >", value, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformGreaterThanOrEqualTo(Integer value) {
            addCriterion("so_platform >=", value, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformLessThan(Integer value) {
            addCriterion("so_platform <", value, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformLessThanOrEqualTo(Integer value) {
            addCriterion("so_platform <=", value, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformIn(List<Integer> values) {
            addCriterion("so_platform in", values, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformNotIn(List<Integer> values) {
            addCriterion("so_platform not in", values, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformBetween(Integer value1, Integer value2) {
            addCriterion("so_platform between", value1, value2, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoPlatformNotBetween(Integer value1, Integer value2) {
            addCriterion("so_platform not between", value1, value2, "soPlatform");
            return (Criteria) this;
        }

        public Criteria andSoChannelIsNull() {
            addCriterion("so_channel is null");
            return (Criteria) this;
        }

        public Criteria andSoChannelIsNotNull() {
            addCriterion("so_channel is not null");
            return (Criteria) this;
        }

        public Criteria andSoChannelEqualTo(Integer value) {
            addCriterion("so_channel =", value, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelNotEqualTo(Integer value) {
            addCriterion("so_channel <>", value, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelGreaterThan(Integer value) {
            addCriterion("so_channel >", value, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelGreaterThanOrEqualTo(Integer value) {
            addCriterion("so_channel >=", value, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelLessThan(Integer value) {
            addCriterion("so_channel <", value, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelLessThanOrEqualTo(Integer value) {
            addCriterion("so_channel <=", value, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelIn(List<Integer> values) {
            addCriterion("so_channel in", values, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelNotIn(List<Integer> values) {
            addCriterion("so_channel not in", values, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelBetween(Integer value1, Integer value2) {
            addCriterion("so_channel between", value1, value2, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelNotBetween(Integer value1, Integer value2) {
            addCriterion("so_channel not between", value1, value2, "soChannel");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionIsNull() {
            addCriterion("so_channel_version is null");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionIsNotNull() {
            addCriterion("so_channel_version is not null");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionEqualTo(String value) {
            addCriterion("so_channel_version =", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionNotEqualTo(String value) {
            addCriterion("so_channel_version <>", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionGreaterThan(String value) {
            addCriterion("so_channel_version >", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionGreaterThanOrEqualTo(String value) {
            addCriterion("so_channel_version >=", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionLessThan(String value) {
            addCriterion("so_channel_version <", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionLessThanOrEqualTo(String value) {
            addCriterion("so_channel_version <=", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionLike(String value) {
            addCriterion("so_channel_version like", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionNotLike(String value) {
            addCriterion("so_channel_version not like", value, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionIn(List<String> values) {
            addCriterion("so_channel_version in", values, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionNotIn(List<String> values) {
            addCriterion("so_channel_version not in", values, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionBetween(String value1, String value2) {
            addCriterion("so_channel_version between", value1, value2, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andSoChannelVersionNotBetween(String value1, String value2) {
            addCriterion("so_channel_version not between", value1, value2, "soChannelVersion");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeIsNull() {
            addCriterion("business_type is null");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeIsNotNull() {
            addCriterion("business_type is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeEqualTo(Byte value) {
            addCriterion("business_type =", value, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeNotEqualTo(Byte value) {
            addCriterion("business_type <>", value, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeGreaterThan(Byte value) {
            addCriterion("business_type >", value, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("business_type >=", value, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeLessThan(Byte value) {
            addCriterion("business_type <", value, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeLessThanOrEqualTo(Byte value) {
            addCriterion("business_type <=", value, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeIn(List<Byte> values) {
            addCriterion("business_type in", values, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeNotIn(List<Byte> values) {
            addCriterion("business_type not in", values, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeBetween(Byte value1, Byte value2) {
            addCriterion("business_type between", value1, value2, "businessType");
            return (Criteria) this;
        }

        public Criteria andBusinessTypeNotBetween(Byte value1, Byte value2) {
            addCriterion("business_type not between", value1, value2, "businessType");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkIsNull() {
            addCriterion("so_user_remark is null");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkIsNotNull() {
            addCriterion("so_user_remark is not null");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkEqualTo(String value) {
            addCriterion("so_user_remark =", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkNotEqualTo(String value) {
            addCriterion("so_user_remark <>", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkGreaterThan(String value) {
            addCriterion("so_user_remark >", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("so_user_remark >=", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkLessThan(String value) {
            addCriterion("so_user_remark <", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkLessThanOrEqualTo(String value) {
            addCriterion("so_user_remark <=", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkLike(String value) {
            addCriterion("so_user_remark like", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkNotLike(String value) {
            addCriterion("so_user_remark not like", value, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkIn(List<String> values) {
            addCriterion("so_user_remark in", values, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkNotIn(List<String> values) {
            addCriterion("so_user_remark not in", values, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkBetween(String value1, String value2) {
            addCriterion("so_user_remark between", value1, value2, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoUserRemarkNotBetween(String value1, String value2) {
            addCriterion("so_user_remark not between", value1, value2, "soUserRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkIsNull() {
            addCriterion("so_cs_remark is null");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkIsNotNull() {
            addCriterion("so_cs_remark is not null");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkEqualTo(String value) {
            addCriterion("so_cs_remark =", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkNotEqualTo(String value) {
            addCriterion("so_cs_remark <>", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkGreaterThan(String value) {
            addCriterion("so_cs_remark >", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("so_cs_remark >=", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkLessThan(String value) {
            addCriterion("so_cs_remark <", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkLessThanOrEqualTo(String value) {
            addCriterion("so_cs_remark <=", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkLike(String value) {
            addCriterion("so_cs_remark like", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkNotLike(String value) {
            addCriterion("so_cs_remark not like", value, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkIn(List<String> values) {
            addCriterion("so_cs_remark in", values, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkNotIn(List<String> values) {
            addCriterion("so_cs_remark not in", values, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkBetween(String value1, String value2) {
            addCriterion("so_cs_remark between", value1, value2, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andSoCsRemarkNotBetween(String value1, String value2) {
            addCriterion("so_cs_remark not between", value1, value2, "soCsRemark");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameIsNull() {
            addCriterion("good_receiver_name is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameIsNotNull() {
            addCriterion("good_receiver_name is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameEqualTo(String value) {
            addCriterion("good_receiver_name =", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameNotEqualTo(String value) {
            addCriterion("good_receiver_name <>", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameGreaterThan(String value) {
            addCriterion("good_receiver_name >", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_name >=", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameLessThan(String value) {
            addCriterion("good_receiver_name <", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_name <=", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameLike(String value) {
            addCriterion("good_receiver_name like", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameNotLike(String value) {
            addCriterion("good_receiver_name not like", value, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameIn(List<String> values) {
            addCriterion("good_receiver_name in", values, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameNotIn(List<String> values) {
            addCriterion("good_receiver_name not in", values, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameBetween(String value1, String value2) {
            addCriterion("good_receiver_name between", value1, value2, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverNameNotBetween(String value1, String value2) {
            addCriterion("good_receiver_name not between", value1, value2, "goodReceiverName");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneIsNull() {
            addCriterion("good_receiver_phone is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneIsNotNull() {
            addCriterion("good_receiver_phone is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneEqualTo(String value) {
            addCriterion("good_receiver_phone =", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneNotEqualTo(String value) {
            addCriterion("good_receiver_phone <>", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneGreaterThan(String value) {
            addCriterion("good_receiver_phone >", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_phone >=", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneLessThan(String value) {
            addCriterion("good_receiver_phone <", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_phone <=", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneLike(String value) {
            addCriterion("good_receiver_phone like", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneNotLike(String value) {
            addCriterion("good_receiver_phone not like", value, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneIn(List<String> values) {
            addCriterion("good_receiver_phone in", values, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneNotIn(List<String> values) {
            addCriterion("good_receiver_phone not in", values, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneBetween(String value1, String value2) {
            addCriterion("good_receiver_phone between", value1, value2, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPhoneNotBetween(String value1, String value2) {
            addCriterion("good_receiver_phone not between", value1, value2, "goodReceiverPhone");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeIsNull() {
            addCriterion("good_receiver_post_code is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeIsNotNull() {
            addCriterion("good_receiver_post_code is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeEqualTo(String value) {
            addCriterion("good_receiver_post_code =", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeNotEqualTo(String value) {
            addCriterion("good_receiver_post_code <>", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeGreaterThan(String value) {
            addCriterion("good_receiver_post_code >", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_post_code >=", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeLessThan(String value) {
            addCriterion("good_receiver_post_code <", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_post_code <=", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeLike(String value) {
            addCriterion("good_receiver_post_code like", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeNotLike(String value) {
            addCriterion("good_receiver_post_code not like", value, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeIn(List<String> values) {
            addCriterion("good_receiver_post_code in", values, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeNotIn(List<String> values) {
            addCriterion("good_receiver_post_code not in", values, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeBetween(String value1, String value2) {
            addCriterion("good_receiver_post_code between", value1, value2, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverPostCodeNotBetween(String value1, String value2) {
            addCriterion("good_receiver_post_code not between", value1, value2, "goodReceiverPostCode");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIsNull() {
            addCriterion("good_receiver_country is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIsNotNull() {
            addCriterion("good_receiver_country is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryEqualTo(String value) {
            addCriterion("good_receiver_country =", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryNotEqualTo(String value) {
            addCriterion("good_receiver_country <>", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryGreaterThan(String value) {
            addCriterion("good_receiver_country >", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_country >=", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryLessThan(String value) {
            addCriterion("good_receiver_country <", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_country <=", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryLike(String value) {
            addCriterion("good_receiver_country like", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryNotLike(String value) {
            addCriterion("good_receiver_country not like", value, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIn(List<String> values) {
            addCriterion("good_receiver_country in", values, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryNotIn(List<String> values) {
            addCriterion("good_receiver_country not in", values, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryBetween(String value1, String value2) {
            addCriterion("good_receiver_country between", value1, value2, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryNotBetween(String value1, String value2) {
            addCriterion("good_receiver_country not between", value1, value2, "goodReceiverCountry");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIsNull() {
            addCriterion("good_receiver_province is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIsNotNull() {
            addCriterion("good_receiver_province is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceEqualTo(String value) {
            addCriterion("good_receiver_province =", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceNotEqualTo(String value) {
            addCriterion("good_receiver_province <>", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceGreaterThan(String value) {
            addCriterion("good_receiver_province >", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_province >=", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceLessThan(String value) {
            addCriterion("good_receiver_province <", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_province <=", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceLike(String value) {
            addCriterion("good_receiver_province like", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceNotLike(String value) {
            addCriterion("good_receiver_province not like", value, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIn(List<String> values) {
            addCriterion("good_receiver_province in", values, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceNotIn(List<String> values) {
            addCriterion("good_receiver_province not in", values, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceBetween(String value1, String value2) {
            addCriterion("good_receiver_province between", value1, value2, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceNotBetween(String value1, String value2) {
            addCriterion("good_receiver_province not between", value1, value2, "goodReceiverProvince");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIsNull() {
            addCriterion("good_receiver_city is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIsNotNull() {
            addCriterion("good_receiver_city is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityEqualTo(String value) {
            addCriterion("good_receiver_city =", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityNotEqualTo(String value) {
            addCriterion("good_receiver_city <>", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityGreaterThan(String value) {
            addCriterion("good_receiver_city >", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_city >=", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityLessThan(String value) {
            addCriterion("good_receiver_city <", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_city <=", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityLike(String value) {
            addCriterion("good_receiver_city like", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityNotLike(String value) {
            addCriterion("good_receiver_city not like", value, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIn(List<String> values) {
            addCriterion("good_receiver_city in", values, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityNotIn(List<String> values) {
            addCriterion("good_receiver_city not in", values, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityBetween(String value1, String value2) {
            addCriterion("good_receiver_city between", value1, value2, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityNotBetween(String value1, String value2) {
            addCriterion("good_receiver_city not between", value1, value2, "goodReceiverCity");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIsNull() {
            addCriterion("good_receiver_county is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIsNotNull() {
            addCriterion("good_receiver_county is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyEqualTo(String value) {
            addCriterion("good_receiver_county =", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyNotEqualTo(String value) {
            addCriterion("good_receiver_county <>", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyGreaterThan(String value) {
            addCriterion("good_receiver_county >", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_county >=", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyLessThan(String value) {
            addCriterion("good_receiver_county <", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_county <=", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyLike(String value) {
            addCriterion("good_receiver_county like", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyNotLike(String value) {
            addCriterion("good_receiver_county not like", value, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIn(List<String> values) {
            addCriterion("good_receiver_county in", values, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyNotIn(List<String> values) {
            addCriterion("good_receiver_county not in", values, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyBetween(String value1, String value2) {
            addCriterion("good_receiver_county between", value1, value2, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyNotBetween(String value1, String value2) {
            addCriterion("good_receiver_county not between", value1, value2, "goodReceiverCounty");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIsNull() {
            addCriterion("good_receiver_area is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIsNotNull() {
            addCriterion("good_receiver_area is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaEqualTo(String value) {
            addCriterion("good_receiver_area =", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaNotEqualTo(String value) {
            addCriterion("good_receiver_area <>", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaGreaterThan(String value) {
            addCriterion("good_receiver_area >", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_area >=", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaLessThan(String value) {
            addCriterion("good_receiver_area <", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_area <=", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaLike(String value) {
            addCriterion("good_receiver_area like", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaNotLike(String value) {
            addCriterion("good_receiver_area not like", value, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIn(List<String> values) {
            addCriterion("good_receiver_area in", values, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaNotIn(List<String> values) {
            addCriterion("good_receiver_area not in", values, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaBetween(String value1, String value2) {
            addCriterion("good_receiver_area between", value1, value2, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaNotBetween(String value1, String value2) {
            addCriterion("good_receiver_area not between", value1, value2, "goodReceiverArea");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressIsNull() {
            addCriterion("good_receiver_address is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressIsNotNull() {
            addCriterion("good_receiver_address is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressEqualTo(String value) {
            addCriterion("good_receiver_address =", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressNotEqualTo(String value) {
            addCriterion("good_receiver_address <>", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressGreaterThan(String value) {
            addCriterion("good_receiver_address >", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressGreaterThanOrEqualTo(String value) {
            addCriterion("good_receiver_address >=", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressLessThan(String value) {
            addCriterion("good_receiver_address <", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressLessThanOrEqualTo(String value) {
            addCriterion("good_receiver_address <=", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressLike(String value) {
            addCriterion("good_receiver_address like", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressNotLike(String value) {
            addCriterion("good_receiver_address not like", value, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressIn(List<String> values) {
            addCriterion("good_receiver_address in", values, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressNotIn(List<String> values) {
            addCriterion("good_receiver_address not in", values, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressBetween(String value1, String value2) {
            addCriterion("good_receiver_address between", value1, value2, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAddressNotBetween(String value1, String value2) {
            addCriterion("good_receiver_address not between", value1, value2, "goodReceiverAddress");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdIsNull() {
            addCriterion("good_receiver_country_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdIsNotNull() {
            addCriterion("good_receiver_country_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdEqualTo(Long value) {
            addCriterion("good_receiver_country_id =", value, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdNotEqualTo(Long value) {
            addCriterion("good_receiver_country_id <>", value, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdGreaterThan(Long value) {
            addCriterion("good_receiver_country_id >", value, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdGreaterThanOrEqualTo(Long value) {
            addCriterion("good_receiver_country_id >=", value, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdLessThan(Long value) {
            addCriterion("good_receiver_country_id <", value, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdLessThanOrEqualTo(Long value) {
            addCriterion("good_receiver_country_id <=", value, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdIn(List<Long> values) {
            addCriterion("good_receiver_country_id in", values, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdNotIn(List<Long> values) {
            addCriterion("good_receiver_country_id not in", values, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdBetween(Long value1, Long value2) {
            addCriterion("good_receiver_country_id between", value1, value2, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountryIdNotBetween(Long value1, Long value2) {
            addCriterion("good_receiver_country_id not between", value1, value2, "goodReceiverCountryId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdIsNull() {
            addCriterion("good_receiver_province_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdIsNotNull() {
            addCriterion("good_receiver_province_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdEqualTo(Long value) {
            addCriterion("good_receiver_province_id =", value, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdNotEqualTo(Long value) {
            addCriterion("good_receiver_province_id <>", value, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdGreaterThan(Long value) {
            addCriterion("good_receiver_province_id >", value, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdGreaterThanOrEqualTo(Long value) {
            addCriterion("good_receiver_province_id >=", value, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdLessThan(Long value) {
            addCriterion("good_receiver_province_id <", value, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdLessThanOrEqualTo(Long value) {
            addCriterion("good_receiver_province_id <=", value, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdIn(List<Long> values) {
            addCriterion("good_receiver_province_id in", values, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdNotIn(List<Long> values) {
            addCriterion("good_receiver_province_id not in", values, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdBetween(Long value1, Long value2) {
            addCriterion("good_receiver_province_id between", value1, value2, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverProvinceIdNotBetween(Long value1, Long value2) {
            addCriterion("good_receiver_province_id not between", value1, value2, "goodReceiverProvinceId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdIsNull() {
            addCriterion("good_receiver_city_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdIsNotNull() {
            addCriterion("good_receiver_city_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdEqualTo(Long value) {
            addCriterion("good_receiver_city_id =", value, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdNotEqualTo(Long value) {
            addCriterion("good_receiver_city_id <>", value, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdGreaterThan(Long value) {
            addCriterion("good_receiver_city_id >", value, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdGreaterThanOrEqualTo(Long value) {
            addCriterion("good_receiver_city_id >=", value, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdLessThan(Long value) {
            addCriterion("good_receiver_city_id <", value, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdLessThanOrEqualTo(Long value) {
            addCriterion("good_receiver_city_id <=", value, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdIn(List<Long> values) {
            addCriterion("good_receiver_city_id in", values, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdNotIn(List<Long> values) {
            addCriterion("good_receiver_city_id not in", values, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdBetween(Long value1, Long value2) {
            addCriterion("good_receiver_city_id between", value1, value2, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCityIdNotBetween(Long value1, Long value2) {
            addCriterion("good_receiver_city_id not between", value1, value2, "goodReceiverCityId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdIsNull() {
            addCriterion("good_receiver_county_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdIsNotNull() {
            addCriterion("good_receiver_county_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdEqualTo(Long value) {
            addCriterion("good_receiver_county_id =", value, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdNotEqualTo(Long value) {
            addCriterion("good_receiver_county_id <>", value, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdGreaterThan(Long value) {
            addCriterion("good_receiver_county_id >", value, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdGreaterThanOrEqualTo(Long value) {
            addCriterion("good_receiver_county_id >=", value, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdLessThan(Long value) {
            addCriterion("good_receiver_county_id <", value, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdLessThanOrEqualTo(Long value) {
            addCriterion("good_receiver_county_id <=", value, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdIn(List<Long> values) {
            addCriterion("good_receiver_county_id in", values, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdNotIn(List<Long> values) {
            addCriterion("good_receiver_county_id not in", values, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdBetween(Long value1, Long value2) {
            addCriterion("good_receiver_county_id between", value1, value2, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverCountyIdNotBetween(Long value1, Long value2) {
            addCriterion("good_receiver_county_id not between", value1, value2, "goodReceiverCountyId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdIsNull() {
            addCriterion("good_receiver_area_id is null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdIsNotNull() {
            addCriterion("good_receiver_area_id is not null");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdEqualTo(Long value) {
            addCriterion("good_receiver_area_id =", value, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdNotEqualTo(Long value) {
            addCriterion("good_receiver_area_id <>", value, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdGreaterThan(Long value) {
            addCriterion("good_receiver_area_id >", value, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdGreaterThanOrEqualTo(Long value) {
            addCriterion("good_receiver_area_id >=", value, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdLessThan(Long value) {
            addCriterion("good_receiver_area_id <", value, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdLessThanOrEqualTo(Long value) {
            addCriterion("good_receiver_area_id <=", value, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdIn(List<Long> values) {
            addCriterion("good_receiver_area_id in", values, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdNotIn(List<Long> values) {
            addCriterion("good_receiver_area_id not in", values, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdBetween(Long value1, Long value2) {
            addCriterion("good_receiver_area_id between", value1, value2, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andGoodReceiverAreaIdNotBetween(Long value1, Long value2) {
            addCriterion("good_receiver_area_id not between", value1, value2, "goodReceiverAreaId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdIsNull() {
            addCriterion("cancel_reason_id is null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdIsNotNull() {
            addCriterion("cancel_reason_id is not null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdEqualTo(Long value) {
            addCriterion("cancel_reason_id =", value, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdNotEqualTo(Long value) {
            addCriterion("cancel_reason_id <>", value, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdGreaterThan(Long value) {
            addCriterion("cancel_reason_id >", value, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdGreaterThanOrEqualTo(Long value) {
            addCriterion("cancel_reason_id >=", value, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdLessThan(Long value) {
            addCriterion("cancel_reason_id <", value, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdLessThanOrEqualTo(Long value) {
            addCriterion("cancel_reason_id <=", value, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdIn(List<Long> values) {
            addCriterion("cancel_reason_id in", values, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdNotIn(List<Long> values) {
            addCriterion("cancel_reason_id not in", values, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdBetween(Long value1, Long value2) {
            addCriterion("cancel_reason_id between", value1, value2, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIdNotBetween(Long value1, Long value2) {
            addCriterion("cancel_reason_id not between", value1, value2, "cancelReasonId");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNull() {
            addCriterion("cancel_time is null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNotNull() {
            addCriterion("cancel_time is not null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeEqualTo(Date value) {
            addCriterion("cancel_time =", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotEqualTo(Date value) {
            addCriterion("cancel_time <>", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThan(Date value) {
            addCriterion("cancel_time >", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("cancel_time >=", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThan(Date value) {
            addCriterion("cancel_time <", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThanOrEqualTo(Date value) {
            addCriterion("cancel_time <=", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIn(List<Date> values) {
            addCriterion("cancel_time in", values, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotIn(List<Date> values) {
            addCriterion("cancel_time not in", values, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeBetween(Date value1, Date value2) {
            addCriterion("cancel_time between", value1, value2, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotBetween(Date value1, Date value2) {
            addCriterion("cancel_time not between", value1, value2, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameIsNull() {
            addCriterion("cancel_cs_name is null");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameIsNotNull() {
            addCriterion("cancel_cs_name is not null");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameEqualTo(String value) {
            addCriterion("cancel_cs_name =", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameNotEqualTo(String value) {
            addCriterion("cancel_cs_name <>", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameGreaterThan(String value) {
            addCriterion("cancel_cs_name >", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameGreaterThanOrEqualTo(String value) {
            addCriterion("cancel_cs_name >=", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameLessThan(String value) {
            addCriterion("cancel_cs_name <", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameLessThanOrEqualTo(String value) {
            addCriterion("cancel_cs_name <=", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameLike(String value) {
            addCriterion("cancel_cs_name like", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameNotLike(String value) {
            addCriterion("cancel_cs_name not like", value, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameIn(List<String> values) {
            addCriterion("cancel_cs_name in", values, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameNotIn(List<String> values) {
            addCriterion("cancel_cs_name not in", values, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameBetween(String value1, String value2) {
            addCriterion("cancel_cs_name between", value1, value2, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsNameNotBetween(String value1, String value2) {
            addCriterion("cancel_cs_name not between", value1, value2, "cancelCsName");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdIsNull() {
            addCriterion("cancel_cs_id is null");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdIsNotNull() {
            addCriterion("cancel_cs_id is not null");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdEqualTo(Long value) {
            addCriterion("cancel_cs_id =", value, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdNotEqualTo(Long value) {
            addCriterion("cancel_cs_id <>", value, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdGreaterThan(Long value) {
            addCriterion("cancel_cs_id >", value, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdGreaterThanOrEqualTo(Long value) {
            addCriterion("cancel_cs_id >=", value, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdLessThan(Long value) {
            addCriterion("cancel_cs_id <", value, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdLessThanOrEqualTo(Long value) {
            addCriterion("cancel_cs_id <=", value, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdIn(List<Long> values) {
            addCriterion("cancel_cs_id in", values, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdNotIn(List<Long> values) {
            addCriterion("cancel_cs_id not in", values, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdBetween(Long value1, Long value2) {
            addCriterion("cancel_cs_id between", value1, value2, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andCancelCsIdNotBetween(Long value1, Long value2) {
            addCriterion("cancel_cs_id not between", value1, value2, "cancelCsId");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceIsNull() {
            addCriterion("order_need_invoice is null");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceIsNotNull() {
            addCriterion("order_need_invoice is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceEqualTo(Byte value) {
            addCriterion("order_need_invoice =", value, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceNotEqualTo(Byte value) {
            addCriterion("order_need_invoice <>", value, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceGreaterThan(Byte value) {
            addCriterion("order_need_invoice >", value, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceGreaterThanOrEqualTo(Byte value) {
            addCriterion("order_need_invoice >=", value, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceLessThan(Byte value) {
            addCriterion("order_need_invoice <", value, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceLessThanOrEqualTo(Byte value) {
            addCriterion("order_need_invoice <=", value, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceIn(List<Byte> values) {
            addCriterion("order_need_invoice in", values, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceNotIn(List<Byte> values) {
            addCriterion("order_need_invoice not in", values, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceBetween(Byte value1, Byte value2) {
            addCriterion("order_need_invoice between", value1, value2, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andOrderNeedInvoiceNotBetween(Byte value1, Byte value2) {
            addCriterion("order_need_invoice not between", value1, value2, "orderNeedInvoice");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdIsNull() {
            addCriterion("warehouse_id is null");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdIsNotNull() {
            addCriterion("warehouse_id is not null");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdEqualTo(Long value) {
            addCriterion("warehouse_id =", value, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdNotEqualTo(Long value) {
            addCriterion("warehouse_id <>", value, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdGreaterThan(Long value) {
            addCriterion("warehouse_id >", value, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdGreaterThanOrEqualTo(Long value) {
            addCriterion("warehouse_id >=", value, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdLessThan(Long value) {
            addCriterion("warehouse_id <", value, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdLessThanOrEqualTo(Long value) {
            addCriterion("warehouse_id <=", value, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdIn(List<Long> values) {
            addCriterion("warehouse_id in", values, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdNotIn(List<Long> values) {
            addCriterion("warehouse_id not in", values, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdBetween(Long value1, Long value2) {
            addCriterion("warehouse_id between", value1, value2, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andWarehouseIdNotBetween(Long value1, Long value2) {
            addCriterion("warehouse_id not between", value1, value2, "warehouseId");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeIsNull() {
            addCriterion("estimate_delivery_time is null");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeIsNotNull() {
            addCriterion("estimate_delivery_time is not null");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeEqualTo(Date value) {
            addCriterion("estimate_delivery_time =", value, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeNotEqualTo(Date value) {
            addCriterion("estimate_delivery_time <>", value, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeGreaterThan(Date value) {
            addCriterion("estimate_delivery_time >", value, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("estimate_delivery_time >=", value, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeLessThan(Date value) {
            addCriterion("estimate_delivery_time <", value, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeLessThanOrEqualTo(Date value) {
            addCriterion("estimate_delivery_time <=", value, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeIn(List<Date> values) {
            addCriterion("estimate_delivery_time in", values, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeNotIn(List<Date> values) {
            addCriterion("estimate_delivery_time not in", values, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeBetween(Date value1, Date value2) {
            addCriterion("estimate_delivery_time between", value1, value2, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateDeliveryTimeNotBetween(Date value1, Date value2) {
            addCriterion("estimate_delivery_time not between", value1, value2, "estimateDeliveryTime");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateIsNull() {
            addCriterion("estimate_receive_date is null");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateIsNotNull() {
            addCriterion("estimate_receive_date is not null");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateEqualTo(Date value) {
            addCriterion("estimate_receive_date =", value, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateNotEqualTo(Date value) {
            addCriterion("estimate_receive_date <>", value, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateGreaterThan(Date value) {
            addCriterion("estimate_receive_date >", value, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateGreaterThanOrEqualTo(Date value) {
            addCriterion("estimate_receive_date >=", value, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateLessThan(Date value) {
            addCriterion("estimate_receive_date <", value, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateLessThanOrEqualTo(Date value) {
            addCriterion("estimate_receive_date <=", value, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateIn(List<Date> values) {
            addCriterion("estimate_receive_date in", values, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateNotIn(List<Date> values) {
            addCriterion("estimate_receive_date not in", values, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateBetween(Date value1, Date value2) {
            addCriterion("estimate_receive_date between", value1, value2, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andEstimateReceiveDateNotBetween(Date value1, Date value2) {
            addCriterion("estimate_receive_date not between", value1, value2, "estimateReceiveDate");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeIsNull() {
            addCriterion("so2do_time is null");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeIsNotNull() {
            addCriterion("so2do_time is not null");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeEqualTo(Date value) {
            addCriterion("so2do_time =", value, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeNotEqualTo(Date value) {
            addCriterion("so2do_time <>", value, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeGreaterThan(Date value) {
            addCriterion("so2do_time >", value, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("so2do_time >=", value, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeLessThan(Date value) {
            addCriterion("so2do_time <", value, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeLessThanOrEqualTo(Date value) {
            addCriterion("so2do_time <=", value, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeIn(List<Date> values) {
            addCriterion("so2do_time in", values, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeNotIn(List<Date> values) {
            addCriterion("so2do_time not in", values, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeBetween(Date value1, Date value2) {
            addCriterion("so2do_time between", value1, value2, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andSo2doTimeNotBetween(Date value1, Date value2) {
            addCriterion("so2do_time not between", value1, value2, "so2doTime");
            return (Criteria) this;
        }

        public Criteria andServiceIpIsNull() {
            addCriterion("service_ip is null");
            return (Criteria) this;
        }

        public Criteria andServiceIpIsNotNull() {
            addCriterion("service_ip is not null");
            return (Criteria) this;
        }

        public Criteria andServiceIpEqualTo(String value) {
            addCriterion("service_ip =", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpNotEqualTo(String value) {
            addCriterion("service_ip <>", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpGreaterThan(String value) {
            addCriterion("service_ip >", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpGreaterThanOrEqualTo(String value) {
            addCriterion("service_ip >=", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpLessThan(String value) {
            addCriterion("service_ip <", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpLessThanOrEqualTo(String value) {
            addCriterion("service_ip <=", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpLike(String value) {
            addCriterion("service_ip like", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpNotLike(String value) {
            addCriterion("service_ip not like", value, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpIn(List<String> values) {
            addCriterion("service_ip in", values, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpNotIn(List<String> values) {
            addCriterion("service_ip not in", values, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpBetween(String value1, String value2) {
            addCriterion("service_ip between", value1, value2, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andServiceIpNotBetween(String value1, String value2) {
            addCriterion("service_ip not between", value1, value2, "serviceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpIsNull() {
            addCriterion("call_service_ip is null");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpIsNotNull() {
            addCriterion("call_service_ip is not null");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpEqualTo(String value) {
            addCriterion("call_service_ip =", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpNotEqualTo(String value) {
            addCriterion("call_service_ip <>", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpGreaterThan(String value) {
            addCriterion("call_service_ip >", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpGreaterThanOrEqualTo(String value) {
            addCriterion("call_service_ip >=", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpLessThan(String value) {
            addCriterion("call_service_ip <", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpLessThanOrEqualTo(String value) {
            addCriterion("call_service_ip <=", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpLike(String value) {
            addCriterion("call_service_ip like", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpNotLike(String value) {
            addCriterion("call_service_ip not like", value, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpIn(List<String> values) {
            addCriterion("call_service_ip in", values, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpNotIn(List<String> values) {
            addCriterion("call_service_ip not in", values, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpBetween(String value1, String value2) {
            addCriterion("call_service_ip between", value1, value2, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andCallServiceIpNotBetween(String value1, String value2) {
            addCriterion("call_service_ip not between", value1, value2, "callServiceIp");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNull() {
            addCriterion("delivery_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNotNull() {
            addCriterion("delivery_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeEqualTo(Date value) {
            addCriterion("delivery_time =", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotEqualTo(Date value) {
            addCriterion("delivery_time <>", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThan(Date value) {
            addCriterion("delivery_time >", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("delivery_time >=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThan(Date value) {
            addCriterion("delivery_time <", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanOrEqualTo(Date value) {
            addCriterion("delivery_time <=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIn(List<Date> values) {
            addCriterion("delivery_time in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotIn(List<Date> values) {
            addCriterion("delivery_time not in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeBetween(Date value1, Date value2) {
            addCriterion("delivery_time between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotBetween(Date value1, Date value2) {
            addCriterion("delivery_time not between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeIsNull() {
            addCriterion("receive_time is null");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeIsNotNull() {
            addCriterion("receive_time is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeEqualTo(Date value) {
            addCriterion("receive_time =", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeNotEqualTo(Date value) {
            addCriterion("receive_time <>", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeGreaterThan(Date value) {
            addCriterion("receive_time >", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("receive_time >=", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeLessThan(Date value) {
            addCriterion("receive_time <", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeLessThanOrEqualTo(Date value) {
            addCriterion("receive_time <=", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeIn(List<Date> values) {
            addCriterion("receive_time in", values, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeNotIn(List<Date> values) {
            addCriterion("receive_time not in", values, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeBetween(Date value1, Date value2) {
            addCriterion("receive_time between", value1, value2, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeNotBetween(Date value1, Date value2) {
            addCriterion("receive_time not between", value1, value2, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeIsNull() {
            addCriterion("delivery_type is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeIsNotNull() {
            addCriterion("delivery_type is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeEqualTo(Long value) {
            addCriterion("delivery_type =", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotEqualTo(Long value) {
            addCriterion("delivery_type <>", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeGreaterThan(Long value) {
            addCriterion("delivery_type >", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeGreaterThanOrEqualTo(Long value) {
            addCriterion("delivery_type >=", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeLessThan(Long value) {
            addCriterion("delivery_type <", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeLessThanOrEqualTo(Long value) {
            addCriterion("delivery_type <=", value, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeIn(List<Long> values) {
            addCriterion("delivery_type in", values, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotIn(List<Long> values) {
            addCriterion("delivery_type not in", values, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeBetween(Long value1, Long value2) {
            addCriterion("delivery_type between", value1, value2, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andDeliveryTypeNotBetween(Long value1, Long value2) {
            addCriterion("delivery_type not between", value1, value2, "deliveryType");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecIsNull() {
            addCriterion("is_do_print_spec is null");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecIsNotNull() {
            addCriterion("is_do_print_spec is not null");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecEqualTo(Byte value) {
            addCriterion("is_do_print_spec =", value, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecNotEqualTo(Byte value) {
            addCriterion("is_do_print_spec <>", value, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecGreaterThan(Byte value) {
            addCriterion("is_do_print_spec >", value, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecGreaterThanOrEqualTo(Byte value) {
            addCriterion("is_do_print_spec >=", value, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecLessThan(Byte value) {
            addCriterion("is_do_print_spec <", value, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecLessThanOrEqualTo(Byte value) {
            addCriterion("is_do_print_spec <=", value, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecIn(List<Byte> values) {
            addCriterion("is_do_print_spec in", values, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecNotIn(List<Byte> values) {
            addCriterion("is_do_print_spec not in", values, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecBetween(Byte value1, Byte value2) {
            addCriterion("is_do_print_spec between", value1, value2, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andIsDoPrintSpecNotBetween(Byte value1, Byte value2) {
            addCriterion("is_do_print_spec not between", value1, value2, "isDoPrintSpec");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetIsNull() {
            addCriterion("order_weight_net is null");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetIsNotNull() {
            addCriterion("order_weight_net is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetEqualTo(BigDecimal value) {
            addCriterion("order_weight_net =", value, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetNotEqualTo(BigDecimal value) {
            addCriterion("order_weight_net <>", value, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetGreaterThan(BigDecimal value) {
            addCriterion("order_weight_net >", value, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_weight_net >=", value, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetLessThan(BigDecimal value) {
            addCriterion("order_weight_net <", value, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_weight_net <=", value, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetIn(List<BigDecimal> values) {
            addCriterion("order_weight_net in", values, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetNotIn(List<BigDecimal> values) {
            addCriterion("order_weight_net not in", values, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_weight_net between", value1, value2, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightNetNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_weight_net not between", value1, value2, "orderWeightNet");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossIsNull() {
            addCriterion("order_weight_gross is null");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossIsNotNull() {
            addCriterion("order_weight_gross is not null");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossEqualTo(BigDecimal value) {
            addCriterion("order_weight_gross =", value, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossNotEqualTo(BigDecimal value) {
            addCriterion("order_weight_gross <>", value, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossGreaterThan(BigDecimal value) {
            addCriterion("order_weight_gross >", value, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_weight_gross >=", value, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossLessThan(BigDecimal value) {
            addCriterion("order_weight_gross <", value, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_weight_gross <=", value, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossIn(List<BigDecimal> values) {
            addCriterion("order_weight_gross in", values, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossNotIn(List<BigDecimal> values) {
            addCriterion("order_weight_gross not in", values, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_weight_gross between", value1, value2, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andOrderWeightGrossNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_weight_gross not between", value1, value2, "orderWeightGross");
            return (Criteria) this;
        }

        public Criteria andVersionNoIsNull() {
            addCriterion("version_no is null");
            return (Criteria) this;
        }

        public Criteria andVersionNoIsNotNull() {
            addCriterion("version_no is not null");
            return (Criteria) this;
        }

        public Criteria andVersionNoEqualTo(Long value) {
            addCriterion("version_no =", value, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoNotEqualTo(Long value) {
            addCriterion("version_no <>", value, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoGreaterThan(Long value) {
            addCriterion("version_no >", value, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoGreaterThanOrEqualTo(Long value) {
            addCriterion("version_no >=", value, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoLessThan(Long value) {
            addCriterion("version_no <", value, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoLessThanOrEqualTo(Long value) {
            addCriterion("version_no <=", value, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoIn(List<Long> values) {
            addCriterion("version_no in", values, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoNotIn(List<Long> values) {
            addCriterion("version_no not in", values, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoBetween(Long value1, Long value2) {
            addCriterion("version_no between", value1, value2, "versionNo");
            return (Criteria) this;
        }

        public Criteria andVersionNoNotBetween(Long value1, Long value2) {
            addCriterion("version_no not between", value1, value2, "versionNo");
            return (Criteria) this;
        }

        public Criteria andUserIpIsNull() {
            addCriterion("user_ip is null");
            return (Criteria) this;
        }

        public Criteria andUserIpIsNotNull() {
            addCriterion("user_ip is not null");
            return (Criteria) this;
        }

        public Criteria andUserIpEqualTo(String value) {
            addCriterion("user_ip =", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpNotEqualTo(String value) {
            addCriterion("user_ip <>", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpGreaterThan(String value) {
            addCriterion("user_ip >", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpGreaterThanOrEqualTo(String value) {
            addCriterion("user_ip >=", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpLessThan(String value) {
            addCriterion("user_ip <", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpLessThanOrEqualTo(String value) {
            addCriterion("user_ip <=", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpLike(String value) {
            addCriterion("user_ip like", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpNotLike(String value) {
            addCriterion("user_ip not like", value, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpIn(List<String> values) {
            addCriterion("user_ip in", values, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpNotIn(List<String> values) {
            addCriterion("user_ip not in", values, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpBetween(String value1, String value2) {
            addCriterion("user_ip between", value1, value2, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserIpNotBetween(String value1, String value2) {
            addCriterion("user_ip not between", value1, value2, "userIp");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeIsNull() {
            addCriterion("user_devicecode is null");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeIsNotNull() {
            addCriterion("user_devicecode is not null");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeEqualTo(String value) {
            addCriterion("user_devicecode =", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeNotEqualTo(String value) {
            addCriterion("user_devicecode <>", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeGreaterThan(String value) {
            addCriterion("user_devicecode >", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeGreaterThanOrEqualTo(String value) {
            addCriterion("user_devicecode >=", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeLessThan(String value) {
            addCriterion("user_devicecode <", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeLessThanOrEqualTo(String value) {
            addCriterion("user_devicecode <=", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeLike(String value) {
            addCriterion("user_devicecode like", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeNotLike(String value) {
            addCriterion("user_devicecode not like", value, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeIn(List<String> values) {
            addCriterion("user_devicecode in", values, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeNotIn(List<String> values) {
            addCriterion("user_devicecode not in", values, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeBetween(String value1, String value2) {
            addCriterion("user_devicecode between", value1, value2, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andUserDevicecodeNotBetween(String value1, String value2) {
            addCriterion("user_devicecode not between", value1, value2, "userDevicecode");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedIsNull() {
            addCriterion("is_user_deleted is null");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedIsNotNull() {
            addCriterion("is_user_deleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedEqualTo(Byte value) {
            addCriterion("is_user_deleted =", value, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedNotEqualTo(Byte value) {
            addCriterion("is_user_deleted <>", value, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedGreaterThan(Byte value) {
            addCriterion("is_user_deleted >", value, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedGreaterThanOrEqualTo(Byte value) {
            addCriterion("is_user_deleted >=", value, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedLessThan(Byte value) {
            addCriterion("is_user_deleted <", value, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedLessThanOrEqualTo(Byte value) {
            addCriterion("is_user_deleted <=", value, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedIn(List<Byte> values) {
            addCriterion("is_user_deleted in", values, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedNotIn(List<Byte> values) {
            addCriterion("is_user_deleted not in", values, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedBetween(Byte value1, Byte value2) {
            addCriterion("is_user_deleted between", value1, value2, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andIsUserDeletedNotBetween(Byte value1, Byte value2) {
            addCriterion("is_user_deleted not between", value1, value2, "isUserDeleted");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdIsNull() {
            addCriterion("create_cs_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdIsNotNull() {
            addCriterion("create_cs_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdEqualTo(Long value) {
            addCriterion("create_cs_id =", value, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdNotEqualTo(Long value) {
            addCriterion("create_cs_id <>", value, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdGreaterThan(Long value) {
            addCriterion("create_cs_id >", value, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdGreaterThanOrEqualTo(Long value) {
            addCriterion("create_cs_id >=", value, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdLessThan(Long value) {
            addCriterion("create_cs_id <", value, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdLessThanOrEqualTo(Long value) {
            addCriterion("create_cs_id <=", value, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdIn(List<Long> values) {
            addCriterion("create_cs_id in", values, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdNotIn(List<Long> values) {
            addCriterion("create_cs_id not in", values, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdBetween(Long value1, Long value2) {
            addCriterion("create_cs_id between", value1, value2, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsIdNotBetween(Long value1, Long value2) {
            addCriterion("create_cs_id not between", value1, value2, "createCsId");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameIsNull() {
            addCriterion("create_cs_name is null");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameIsNotNull() {
            addCriterion("create_cs_name is not null");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameEqualTo(String value) {
            addCriterion("create_cs_name =", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameNotEqualTo(String value) {
            addCriterion("create_cs_name <>", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameGreaterThan(String value) {
            addCriterion("create_cs_name >", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameGreaterThanOrEqualTo(String value) {
            addCriterion("create_cs_name >=", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameLessThan(String value) {
            addCriterion("create_cs_name <", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameLessThanOrEqualTo(String value) {
            addCriterion("create_cs_name <=", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameLike(String value) {
            addCriterion("create_cs_name like", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameNotLike(String value) {
            addCriterion("create_cs_name not like", value, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameIn(List<String> values) {
            addCriterion("create_cs_name in", values, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameNotIn(List<String> values) {
            addCriterion("create_cs_name not in", values, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameBetween(String value1, String value2) {
            addCriterion("create_cs_name between", value1, value2, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateCsNameNotBetween(String value1, String value2) {
            addCriterion("create_cs_name not between", value1, value2, "createCsName");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}